USE [MyCarat]
GO
/****** Object:  StoredProcedure [dbo].[sp_GetUserBasicByName]    Script Date: 05/30/2012 18:25:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
if exists(select * from sysobjects where id=object_id('sp_GetUserBasicByName') )
        drop proc sp_GetUserBasicByName
GO
create proc [dbo].[sp_GetUserBasicByName]
  @name varchar(20)

  as
  -- begin tran
   
   select    
		   ID,
           name ,
		   password ,
           email ,
           phone ,
           address ,
           postcode ,
           rankID ,
           firstName,
           lastName,
           country
    from UserBasic
    where name= @name 
             
     
   
   
   
--  commit tran  
    
    